Bassam Khalil
Bassam Khalil
-
Re: Excel Conditional Statement formula alternative for Smartsheet
Hi @jfvbms2023, try the following formula: =IF(CONTAINS("pallet", LOWER([# of Pallets/Dimensions/Weight]@row)), LEFT([# of Pallets/Dimensions/Weight]@row, 2), "")1 · -
Re: How to Combine Two VLOOKUP Formulas into 1
Hi @SergeantPup, In Smartsheet, you can achieve the functionality you're looking for by using the IFERROR function, rather than IF or OR. The IFERROR function allows you to specify a fallback formula…1 · -
Re: Conditional formatting with dates
Hi @Erica Cole, to do that you need to add a helper column call it "Remaining Time" for example and use the following formula in this column and convert it to column format formula: =TODAY(…1 · -
Re: How can I export Schedule view?
Hi @Jenna S, To export Schedule view or resource bookings in Schedule from Smartsheet, especially when creating a custom dashboard and needing more flexibility than what's provided in the People or P…1 · -
Re: Column Formula for a future date, 3 months before annual start date
Hi @PEvansLC, we can't directly iterate over years or dynamically generate column values based on another column's multi-year span directly within a single formula. However, you can achieve your goal…2 ·
